MySQL Select
MySQL SELECT
MYSQL SELECT DISTINCT
MYSQL Where Clause
MYSQL AND, OR, NOT
MySQL ORDER BY
MySQL LIMIT Clause
MySQL MIN() and MAX()
MySQL COUNT(), AVG() and SUM()
MYSQL IN and NOT IN Operators
MySQL BETWEEN Operator
MySQL LIKE Operator
MySQL GROUP BY Statement
MySQL HAVING Clause
MySQL EXISTS
MySQL INSERT INTO SELECT Statement
MySQL CASE Statement
MySQL ANY and ALL Operators
MySQL NULL Functions
MySQL AUTO INCREMENT
MySQL Subquery

MySQL Joins
MYSQL Inner Join
MYSQL LEFT JOIN
MYSQL RIGHT JOIN
MYSQL CROSS JOIN
MYSQL SELF JOIN

MySQL Database & Tables
MySQL CREATE and DROP DATABASE
MySQL CREATE and DROP TABLE Statement
MySQL ALTER TABLE Statement

MySQL Insert, Update & Delete
MySQL INSERT
MySQL UPDATE
MySQL DELETE

MySQL Constraints
MySQL NOT NULL Constraint
MySQL UNIQUE Constraint
MySQL PRIMARY KEY Constraint
MySQL FOREIGN KEY Constraint
MySQL CHECK Constraint
MySQL DEFAULT Constraint
MySQL CREATE INDEX Statement

MySQL Additional Topics
MYSQL VIEWS
MySQL Stored Procedures

MySQL DELETE Statement

The DELETE statement in mysql is used to delete the records in the table. We can delete(remove) the records by specifying the condition in where clause.

Syntax for DELETE statement

DELETE FROM table_name WHERE condition;

If the condition is specified then it will delete the records from the table that satisfies the condition.
If no condition is specified using where clause, then all the records in the table will be deleted.
Consider the following table.

empno	name	age	role	location
001	Andrew	30	Manager	India
002	Beslin	28	Business Analyst	India
003	Joanna	23	Senior Developer	USA
004	Rayan	26	Technical Lead	Canada

To delete the employee with the empno 004 we use the following query

delete from employee where empno=004;

We can also delete using the name with the following query

 delete from employee where name='Rayan';

Delete all records

To delete all the records in the table we provide delete statement without any condition.

Syntax to delete all records

delete from employee;

MySQL DELETE Statement

Delete all records

Categories

Most Read